package com.yunji.base.mapper;

import com.github.yulichang.base.MPJBaseMapper;
import com.yunji.base.domain.AllianceDO;
import com.yunji.base.vo.AllianceDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description: 加盟Mapper接口$
 * @Author: HuaAo
 * @Date: 2024-04-02$
 */
public interface IAllianceMapper extends MPJBaseMapper<AllianceDO> {

    @Select({"<script>select distinct ${searchFiled} FROM s_alliance WHERE del_flag=0",
            "<if test='phone != null'>AND `phone` LIKE concat('%',#{phone},'%')</if>",
            "<if test='name != null'>AND `name` LIKE concat('%',#{name},'%')</if></script>"})
    List<String> searchTableFiled(AllianceDTO dto);
}

